You are here: Function Reference > Database Functions > ODBC Handler

ODBC Handler

The standard handler name for ODBC is ODBC. Here is an example:

< DBHandler:ODBC >

Install = SQW32->SQInstallHandlerorInstallMod = SQW32InstallFunc = SQInstallHandler

The Install option specifies the DLL module name and handler function name. This function is linked dynamically when the handler is initialized. Actually, the above definitions are not necessary for ODBC support. The database library will default the module and function name to the values shown.

Additional values can be optionally set in the INI file.

Server = Server name (default is "MS SQL Server")

The Server option relates to an ODBC term which is specified on the control panel which essentially provides the name of a driver. MS SQL Server is the default if the option is omitted.

Qualifier = Qualifier (no default)

The Qualifier option provides data source specific information, for example, the database name for an Access database.

User = User ID (no default)

PassWd = User password (no default)

The User and PassWd (password) options provide a way to automatically log on to the database. Not all drivers support this usage. When unspecified, some ODBC drivers may display a logon window and prompt for the information. Some drivers will ignore the options if the connected database manager does not require or support logging in.

CreateIndex = Yes / No (default is Yes)

CreateTable = Yes / No (default is Yes)

The CreateTable and CreateIndex options can be used to prevent time delay while a table is checked for existence. In this way, the normal capabilities of the connected driver may be overridden. When set to No, any attempt to open the file with a mode of CREATE_IF_NEW will automatically be rejected. Some drivers may not support creating a table or index, and may require these options to be set to No.

.